SELECT * FROM sysobjects

GO

SELECT * FROM syscolumns

GO